Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4 ?>
5 <?php
6 SESSION_START();
7 ?>
8 <!DOCTYPE html>
9 <html>
10
11 <head>
12 <meta charset="utf-8">
13 <meta name="viewport" content="width=device-width, initial-scale=1.0">
14 <title>school management system</title>
15 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
16 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
17 <link href="assets/css/loader.css" rel="stylesheet" />
18 <script src="assets/js/canvasjs.min.js"></script>
19 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
20 <script src="assets/js/jquery-3.2.1.js"></script>
21 </head>
22
23 <body >
24 <!--end of heading section-->
25 <ul class="nav navbar-right top-nav">
26 <div class="dropdown">
27 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
28 <?php
29 //Check to see if the user is logged in.if not redirect user to the loging page.
30
31 if(isset($_SESSION['fname']))
32 {
33 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
34 }else{
35 echo "<script type='text/javascript'>
36 alert( 'You must Log in to use the system');
37 </script>";
38 echo "<script>
39 window.location = 'index.php'
40 </script>";
41 }
42 ?>
43 <span class="caret"></span></button>
44 <ul class="dropdown-menu">
45 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
46 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
47 <li class="divider"></li>
48 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
49 </ul>
50 </div>
51 </ul>
52 <!--************************************************-->
53 <div style="
54 font-family:Nyala, Arial;
55 text-align: left;
56 background-color: #526F35;
57 padding: 20px;
58 color:white;
59 width: 100%;
60 height: 150px;">
61 <!--This codes to load the image loader-->
62 <div id="loading">
63 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
64 </div>
65 <!--this is the heading section-->
66 <h2>
67 <?php
68 $sql="SELECT * FROM companyinfo";
69 $result=mysqli_query($db,$sql) or die("error getting data");
70 $num_rows=mysqli_num_rows($result);
71 while($row=mysqli_fetch_array($result))
72 {
73 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
74 $cname = $row['cname'];
75 $cemail = $row['cemail'];
76 $ccontact = $row['ccontact'];
77 $clocation = $row['clocation'];
78 }?>
79 <?php
80 echo $cname;
81 ?>
82
83 <div style="float:right; font-size:20px;text-align:right;">
84
85 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
86 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
87 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
88
89 </div>
90 </h2>
91 </div>
92 <!--end of heading section-->
93
94 <div>
95 <ul class="nav nav-tabs">
96 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
97 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
98 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
99 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
100 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
101 <li class="active"><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
102 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
103 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
104 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
105 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
106
107 </ul>
108 <div class="tab-content">
109 <div class="tab-pane active" role="tabpanel" id="tab-1">
110
111 <p>
112 <div class="table-responsive" >
113 <!--****************************************************************************-->
114 <div class="container" style="width:100%">
115
116 <ul class="nav nav-tabs">
117 <li ><a href="markstep1.php">Choose Class <img src="assets/img/new.png"> </a></li>
118
119 <li ><a href="markstep3.php">Enter Marks<img src="assets/img/view2.png"></a></li>
120
121
122 <li ><a href="markstep6.php">Export/import CSV </a></li>
123 <li class="active"><a href="markstep7.php">Print Transcript <img src="assets/img/print.png"></a></li>
124 </ul>
125 <br>
126
127 </div>
128
129 <!--*************************************************************************************************************************-->
130 <?php
131 $id=$_GET['id'];
132 $sql="SELECT * FROM course as t, studentstable as r
133 WHERE
134 r.course_id = t.course_id
135 AND admission_number='$id' ";
136
137 $result = mysqli_query($db, $sql);
138 while($row=mysqli_fetch_array($result))
139 {
140 $admission_number=$row['admission_number'];
141 $course_id=$row['course_id']; //can change
142 }
143 ?>
144
145
146
147 <h4><center><h4><strong>Generate Transcript</strong></h4></center></h4>
148
149 <div class="row">
150 <div class="col-sm-3">
151 </div>
152 <div class="col-sm-6" >
153
154
155 <form method="get" action="reports_all/pdftranscript.php">
156
157 <table cellpadding="0" cellspacing="0" border="0" class="table" id="example">
158 <tr>
159 <td>
160 <label>Enter admission to generate Transcript</label>
161 <input type="text" name="admission_number" class="form-control"
162 value="<?php echo $admission_number ;?>" >
163 </td>
164 </tr>
165 <tr>
166 <td>
167 <label>Class</label>
168 <input type="text" name="course_id" class="form-control"
169 value="<?php echo $course_id ;?>" >
170 </td>
171 </tr>
172 <td>
173 <label>Year</label>
174
175 <?php
176 // set start and end year range
177 $yearArray = range(2016, 2050);
178 ?>
179 <!-- displaying the dropdown list -->
180 <select name="year" class="form-control">
181 <?php
182 foreach ($yearArray as $year) {
183 // if you want to select a particular year
184 $selected = ($year == 2017) ? 'selected' : '';
185 echo '<option '.$selected.' value="'.$year.'">'.$year.'</option>';
186 }
187 ?> </select>
188 </td>
189 </tr>
190
191 <tr>
192 <td>
193 <label>Term</label>
194
195 <select class="form-control" name="term">
196 <?php
197 include('connect.php');
198 $sql1="SELECT * FROM term";
199 $records1=mysqli_query($db,$sql1);
200 while($row=mysqli_fetch_array($records1))
201 {
202 echo "<option>".$row['termname']."</option>";
203
204 }
205 ?></select>
206 </td>
207 <tr>
208 <input type="HIDDEN" name="date" value="<?php echo date('D-M-Y') ; ?>">
209
210 <tr>
211 <td><input type="submit" name="submit" value="Generate" ></td>
212 </tr>
213 </table>
214 </form>
215
216
217 <!--****************************************************************************-->
218
219
220 </div>
221 <div style="height:auto; width:300px; border:1px solid green; float:right">
222 Hello user. Kindly follow one the following steps for better results.<br>
223 if MARKS=TERM 1, customer care excluded,........to be continued
224 </div>
225
226
227 </p>
228
229 </div>
230
231 </div>
232 </div>
233
234 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
235 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
236 </div>
237 <script src="assets/js/jquery.min.js"></script>
238 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
239 <script src="assets/js/affix.js"></script>
240 <script src="assets/js/alert.js"></script>
241 <script src="assets/js/alert1.js"></script>
242 <script src="assets/js/bootstrap.js"></script>
243 <script src="assets/js/bootstrap.min.js"></script>
244 <script src="assets/js/bootstrap-datepicker.js"></script>
245 <script src="assets/js/bootstrap-wysihtml5.js"></script>
246 <script src="assets/js/button.js"></script>
247 <script src="assets/js/carousel.js"></script>
248 <script src="assets/js/chosen.jquery.min.js"></script>
249 <script src="assets/js/ckeditor.js"></script>
250 <script src="assets/js/collapse.js"></script>
251 <script src="assets/js/color.js"></script>
252 <script src="assets/js/dropdown.js"></script>
253 <script src="assets/js/DT_bootstrap.js"></script>
254 <script src="assets/js/dynamic.js"></script>
255 <script src="assets/js/ie-emulation-modes-warning.js"></script>
256 <script src="assets/js/jquery.dataTables.js"></script>
257 <script src="assets/js/jquery.dataTables.min.js"></script>
258 <script src="assets/js/jquery.dialog.js"></script>
259 <script src="assets/js/jquery.hoverdir.js"></script>
260 <script src="assets/js/jquery.jgrowl.js"></script>
261 <script src="assets/js/jquery.knob.js"></script>
262 <script src="assets/js/jquery.uniform.min.js"></script>
263 <script src="assets/js/jquery-1.8.3.min.js"></script>
264 <script src="assets/js/jquery-1.9.1.js"></script>
265 <script src="assets/js/jquery-1.9.1.min.js"></script>
266 <script src="assets/js/jquery-1.10.2.js"></script>
267 <script src="assets/js/jquery-1.11.0.js"></script>
268 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
269 <script src="assets/js/jquery-ui-1.10.3.js"></script>
270 <script src="assets/js/modal.js"></script>
271 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
272 <script src="assets/js/myjquery.js"></script>
273 <script src="assets/js/myjquery1.js"></script>
274 <script src="assets/js/npm.js"></script>
275 <script src="assets/js/popover.js"></script>
276 <script src="assets/js/profile.js"></script>
277 <script src="assets/js/raphael-min.js"></script>
278 <script src="assets/js/sb-admin-2.js"></script>
279 <script src="assets/js/scripts.js"></script>
280 <script src="assets/js/scrollspy.js"></script>
281 <script src="assets/js/tab.js"></script>
282 <script src="assets/js/tooltip.js"></script>
283 <script src="assets/js/transition.js"></script>
284 <script src="assets/js/wysihtml5-0.3.0.js"></script>
285 <script language="javascript" type="text/javascript">
286 $(window).load(function()
287 {
288 $('#loading').hide();
289 });
290 </script>
291 </body>
292
293 </html>